RCG Trax System System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| visits-get-visits-response | Get Visits Response Mapping |
visits-get-visits-response
Get Visits Response Mapping
Source:
./src/main/resources/dwl/visits-get-visits-response.dwl
Mapping Tables
Maps Trax System Response to CIM Format
| CIM | Trax | Description | |
|---|---|---|---|
| traxSessionId | session_uid | Session UUID generated by Trax. | |
| traxProjectName | project_name | Project Name as provided by Trax. | |
| traxStoreNumber | store_number | Client store unique identifier. | |
| traxExternalRouteId | external_route_id | Client route unique identifier. | |
| traxSessionDate | session_date | Visit date in local time zone. | |
| traxSessionStartTime | session_start_time | The TimeStamp of the session start time as provided by the client application. | |
| traxSessionEndTime | session_end_time | The TimeStamp of the session end time as provided by the client application. | |
| traxVisitorIdentifier | visitor_identifier | The user email. | |
| traxVisiServiceType | visit_service_type | The visit type. | |
| traxVisitTypeId | visit_type_uid | The visit UID. | |
| traxVisitTypeName | visit_type_name | The visit name. | |
| traxResultsMetadataGenerationTime | results_metadata.generation_time | The Unix Epoch TimeStamp of analysis data generation. | |
| traxResultsMetadataVersion | results_metadata.version | Report version. | |
| traxResultsMetadataStatus | results_metadata.status | Status of the report. | |
| traxClientSessionId | client_session_uid | Session UUID generated by the client. | |
| traxGPScoordinatesLatitude | GPS_coordinates_latitude | Latitude coordinate of the visits as captured by the GPS. | |
| traxGPScoordinatesLongitude | GPS_coordinates_longitude | Longitude coordinate of the visits as captured by the GPS. | |
| traxStoreGPScoordinatesLatitude | store_GPS_coordinates_latitude | Latitude coordinate of the visit store as entered in the DB. | |
| traxStoreGPScoordinatesLongitude | store_GPS_coordinates_longitude | Longitude coordinate of the store as entered in the DB. | |
| traxDeviceModel | device_model | Device Model by which the visit was conducted. | |
| traxApplicationVersion | application_version | Application version of the mobile device used in the visit. | |
| traxVisitUploadingEndTime | visit_uploading_end_time | EndTime of last image uploaded in the session. | |
| traxSessionClosedTTL | session_closed_by_TTL | Application version of the mobile device used in the visit. | |
| traxPartialGPSCoordinates | partial_GPS_coordinates | GPS coordinates. | |
| traxClientType | client_type | Type of client in the session. | |
| traxNumerator | numerator | Numerator result for KPI result represented as ratio. | |
| traxDenominator | denominator | Denominator result for KPI result represented as ratio | or any auxiliary result. |
| actualDecimal | result | KPI result. | |
| traxScore | score | KPI score. | |
| traxTarget | target | KPI target. | |
| traxWeight | Weight | KPI weight. | |
| traxkpiName | name | Name of the Product. | |
| traxEntitytype | type | Entity type. | |
| traxEntityId | uid | Entity UUID. |